package com.cqu.lpss.mapper;

import com.cqu.lpss.pojo.Contestants;
import com.cqu.lpss.pojo.Image;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

@Mapper
public interface ContestantsMapper {
    public Contestants findByIdAndPassword(String conId,String conPassword);
    public Contestants findById(String conId);
    public int totalnum();
    public List<Contestants> list(String conId, String conName,
                                  Integer conLowAge, Integer conHighAge,
                                  Integer conGender, String conEmail,
                                  String conPhone, Integer conClass);
    public Contestants findByPhone(String phone);
    public int insert(
            String              conId,
            String              conName,
            Integer             conAge,
            Integer             conGender,
            String              conEmail,
            String              conPassword,
            String              conPhone,
            Integer             conClass,
            java.sql.Date       conBirth,
            java.sql.Timestamp  conCreatetime,
            java.sql.Timestamp  conUpdatetime);

    public int PersonCenter_upload(String newpassword,String phone,String email,String Id);
    public List<Map<Integer, Long> > UploadedCon_groupByClass();
    public List<Map<Integer, Long> > passfirstPrj_groupByClass();
}
